{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Finish Times (2)","Finish Times","Fleet 1","Fleet 2","Fleet 3","Fleet 4","Fleet 1 and 2 Combo","Fleet 3 and 4 Combo"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Finish Times (2)","index":0,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["MUST",null,"FLEET 1"]
["BE",null,"FLEET 2"]
["IN ALPHA",null,"FLEET 3"]
["ORDER",null,"FLEET 4"]
[null,null,null,null,null,"Finish Time"]
["BOAT NAME","FLEET","BOAT","SAIL #","SKIPPER","MINUTES","SECONDS"]
["Bandit",1,"J/24",2792,"Cliborne"]
["Blunder Bus",1,"J/24",null,"Hardy"]
["Boogie Board",1,"J/24",1742,"Maloney"]
["Catch 22",1,"J22",826,"Schiable"]
["Dark Horse",1,"J/24",1024,"Forqurean"]
["Fox Trot",1,"Colgate 26",null,"Haddon"]
["Rascal",1,"J/24",3511,"Phillip"]
["Time Warp",1,"J/24",1248,"Sampson"]
["UDO",1,"VX One",119,"Gietl"]
["Destiny",2,"Alerion 20",6,"Whitt"]
["Fools Game",2,"Pearson 26",1183,"Hull"]
["Gotcha",2,"S-2 6.7",75,"Theis"]
["Majical",2,"Cal 25",1687,"Witten"]
["Severence",2,"C&C 25",14755,"Evans"]
["Stoic",2,"Harbor 20",330,"Hemler"]
["StressLess",2,"Harbor 20",212,"Breckenridge"]
["Synergy",2,"Harbor 20",215,"Miekina"]
["Circle Back",3,"Catalina 22","C22","Nash"]
["Miss Virginia",3,"Hunter 23.5",1309,"Perdue"]
["Norse Raider",3,"Ericson 23",23,"Short"]
["Second Wind",3,"Ericson 23",470,"Schraw"]
["Tundra Swan",3,"Hunter 23",1256,"Gobble"]
["Alarming",4,"S-2 9.2",505,"Oginz"]
["BILL",4,"Hunter 356",null,"Gillespie"]
["Felicite",4,"S-2 27 IB",13,"Johnson"]
["Got to Go",4,"Catalina 30",97,"Forrester"]
["Janet Anne",4,"Catalina 25",5155,"Tunnell"]
["Little Wing",4,"Beneteau 29",485,"DeMestro"]
["More Mischief",4,"Beneteau 285",144,"Gearhart"]
["Willaway",4,"Columbia 29",222,"Conover"]

{"sheet":"Finish Times","index":1,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Minutes  ------->",0,"FLEET 1",null,null,null,null,null,"2017-09-09","<----Enter Race Date"]
["After",{"$f":"B4","v":0},"FLEET 2",null,null,null,null,null,"2017 Fall Series Race #1","<----Enter Race Description (EG:  2017 Spring Series Race #4)"]
["First ------------->",5,"FLEET 3",null,null,null,null,null,"Maloney, Tunnell","<----Enter Race Committee Name"]
["Start",{"$f":"B6","v":5},"FLEET 4",null,null,null,null,null,"Windward / Leeward Course 2X for Fleets I and II, 1X for Fleets III and IV ",null,"<---Replace with description of the day's racing conditions"]
[null,null,null,null,null,"Finish Time"]
["BOAT NAME","FLEET","BOAT","SAIL #","SKIPPER","MINUTES","SECONDS"]
["Alarming",4,"S-2 9.2",505,"Oginz",100,29,1]
["Always Something",3,"Hunter 23",1256,"Gobble",99,43,2]
["Bandit",1,"J/24",2792,"Cliborne",48,7,3]
["Boogie Board",1,"J/24",1742,"Maloney",null,null,4]
["Catch 22",1,"J22",826,"Schiable",82,22,5]
["Dark Horse",1,"J/24",1024,"Forqurean",78,34,6]
["Destiny",2,"Alerion 20",6,"Whitt",82,25,7]
["Felicite",4,"S-2 27 IB",13,"Johnson",101,34,8]
["Fenix",2,"San Juan 24",556,"Firing",null,null,9]
["Fever",3,"Ericson 23",269,"Short",null,null,10]
["Fools Game",1,"Pearson 26",1183,"Hull",97,46,11]
["Gotcha",2,"S-2 6.7",75,"Theis",null,null,12]
["Little Wing",4,"Beneteau 29",485,"DeMestro",null,null,13]
["Miss Virginia",3,"Hunter 23.5",1309,"Perdue",null,null,14]
["More Mischief",4,"Beneteau 285",144,"Gearhart",null,null,15]
["Rascal",1,"J/24",3511,"Phillip",63,25,16]
["Second Wind",3,"Ericson 23",470,"Schraw",100,19,17]
["Severence",1,"C&C 25",14755,"Evans",null,null,18]
["Stoic",2,"Harbor 20",330,"Hemler",80,5,19]
["StressLess",2,"Harbor 20",212,"Toone",82,58,20]
["Synergy",2,"Harbor 20",215,"Miekina",null,null,21]
["Time Warp",1,"J/24",1248,"Sampson",null,null,22]
["UDO",1,"VX One",119,"Gietl",82,12,23]
["Willawaw",4,"Columbia 29",222,"Conover",82,15,24]
["Courageous",2,"Harbor 20",278,"Tunnell/Malon",null,null,25]
["Debra Ann",3,"O'Day 25 CB",null,"Perdue",84,21,26]
["Ie Ie Bang Bang",4,"Hunter 365",8,"Gillespie",null,null,27]
["z",null,null,null,null,null,null,28]
["zz",null,null,null,null,null,null,29]
["zzz",null,null,null,null,null,null,30]
["zzzz",null,null,null,null,null,null,31]

{"sheet":"Fleet 1","index":2,"n_rows":30,"n_cols":37,"rows_kept":30,"cut":false,"hidden":false,"merged":[[4,0,4,14],[6,0,6,14],[7,6,7,7],[7,8,7,9],[7,10,7,11],[5,5,5,8]]}
["Control Z to run macro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,"Winner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(N10:N24)","v":44.968847352024923}]
[{"$f":"'Finish Times'!B4","v":0},"<-----Minutes after first start"]
[]
["Blackwater Yacht Racing Association - Race Results - Fleet 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test"]
[null,null,null,"Date: ",{"$f":"'Finish Times'!I4","v":"2017-09-09"},{"$f":"'Finish Times'!I5","v":"2017 Fall Series Race #1"},null,null,null,null,{"$f":"CONCATENATE(\"RC:\",\" \",'Finish Times'!I6)","v":"RC: Maloney, Tunnell"},null,null,null,null,null,null,null,null,null,null,null,null,null,"new tcf =","should ="]
[{"$f":"'Finish Times'!I7","v":"Windward / Leeward Course 2X for Fleets I and II, 1X for Fleets III and IV "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time","Time","Approx",null,"Finish Calculations",null,null,null,null,"Winner Adj Time","Winner Adj Time",null,null,"# of Boats"]
[null,null,null,null,null,null,"Handicap",null,"TCF",null,"Finish Time",null,"Calc(1)","Adj.(2)",null,"Behind","Behind","H'cap",null,"S for Spin",null,null,null,null,"/observed",null,null,null,{"$f":"MAX(AC10:AC24)","v":6}]
["Skipper","Boat Name","Initials","Guest?","Boat","Sail #","Spin*","Non-Spin*","Spin*","Non-Spin*","Min.","Sec.","Min.dd","Time","Place","Winner","Boat Ahead","to win",null,"N for non"]
["Cliborne","Bandit",null,null,"J/24",2792,170,{"$f":"IFERROR(G10+15,\"\")","v":185},{"$f":"IF(T10 = \"s\",1000/(900+G10),\"\")","v":0.93457943925233644},{"$f":"IF(T10 =\"n\",1000/(900+H10),\"\")","v":""},{"$f":"IF($AK10>0,(VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":48},{"$f":"IF($AK10>0,(VLOOKUP($B10,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":7},{"$f":"IF(AK10>0,(K10+L10/60)-A$3,\" \")","v":48.116666666666667},{"$f":"IFERROR(U10,\" \")","v":44.968847352024923},1,{"$f":"IFERROR(N10-$Y$2,\"\")","v":0},null,{"$f":"IFERROR(ROUND((1000/Y10)-900,0),\"\")","v":170},null,"s",{"$f":"IFERROR(IF(M10>0,IF(T10=\"s\",M10*I10,0)+IF(T10=\"n\",M10*J10,0),\" \"),\"\")","v":44.968847352024923},{"$f":"IFERROR(RANK(N10,$N$10:$N$24,1),\"\")","v":1},null,null,{"$f":"IFERROR($Y$2/M10,\"\")","v":0.93457943925233644},{"$f":"IFERROR(M10*Y10,\"\")","v":44.968847352024923},null,1,1,0,null,null,null,55,39,null,{"$f":"(VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE))","v":48}]
["Forqurean","Dark Horse",null,null,"J/24",1024,170,185,0.93457943925233644,{"$f":"IF(T11 =\"n\",1000/(900+H11),\"\")","v":""},{"$f":"IF($AK11>0,(VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":78},{"$f":"IF($AK11>0,(VLOOKUP($B11,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":34},{"$f":"IF(AK11>0,(K11+L11/60)-A$3,\" \")","v":78.566666666666663},73.426791277258559,3,28.457943925233636,14.158878504672892,847,null,"s",{"$f":"IFERROR(IF(M11>0,IF(T11=\"s\",M11*I11,0)+IF(T11=\"n\",M11*J11,0),\" \"),\"\")","v":73.426791277258559},3,null,null,0.5723654732968807,{"$f":"IFERROR(M11*Y11,\"\")","v":44.968847352024923},null,2,3,28.457943925233636,14.158878504672892,null,null,56,22,null,{"$f":"(VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE))","v":78}]
["Maloney","Boogie Board",null,null,"J/24",1742,170,185,0.93457943925233644,{"$f":"IF(T12 =\"n\",1000/(900+H12),\"\")","v":""},{"$f":"IF($AK12>0,(VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK12>0,(VLOOKUP($B12,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""}," ","","","","","",null,"s","","",null,null,"","",null,2,"","","",null,null,54,9,null,{"$f":"(VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["Phillip","Rascal",null,null,"J/24",3511,170,185,0.93457943925233644,{"$f":"IF(T13 =\"n\",1000/(900+H13),\"\")","v":""},{"$f":"IF($AK13>0,(VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":63},{"$f":"IF($AK13>0,(VLOOKUP($B13,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":25},63.416666666666664,59.267912772585667,2,14.299065420560744,14.299065420560744,510,null,"s",59.267912772585667,2,null,null,0.7091014037112997,44.968847352024923,null,3,2,14.299065420560744,14.299065420560744,null,null,62,59,null,{"$f":"(VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE))","v":63}]
["Sampson","Time Warp",null,null,"J/24",1248,170,185,0.93457943925233644,{"$f":"IF(T14 =\"n\",1000/(900+H14),\"\")","v":""},{"$f":"IF($AK14>0,(VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK14>0,(VLOOKUP($B14,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""}," ","","",null,"","",null,"s","","",null,null,"","",null,3,"",null,"",null,null,59,12,null,{"$f":"(VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["Schiable","Catch 22",null,null,"J22",826,177,192,0.92850510677808729,"",{"$f":"IF($AK15>0,(VLOOKUP($B15,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":82},{"$f":"IF($AK15>0,(VLOOKUP($B15,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":22},82.36666666666666,76.477870628288457,4,31.509023276263534,3.0510793510298981,932,null,"s",76.477870628288457,4,null,null,0.54595929605857862,44.968847352024923,null,4,4,31.509023276263534,3.0510793510298981,null,null,56,58,null,{"$f":"(VLOOKUP($B15,'Finish Times'!$A$10:$G$40,6,FALSE))","v":82}]
["Gietl","UDO",null,null,"VX One",119,103,118,0.99700897308075775,"",{"$f":"IF($AK16>0,(VLOOKUP($B16,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":82},{"$f":"IF($AK16>0,(VLOOKUP($B16,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":12},82.2,81.954137587238293,5,36.98529023521337,5.4762669589498358,928,null,"s",81.954137587238293,5,null,null,0.54706626948935433,44.96884735202493,null,5,5,36.98529023521337,5.4762669589498358,null,null,null,null,null,{"$f":"(VLOOKUP($B16,'Finish Times'!$A$10:$G$40,6,FALSE))","v":82}]
["Evans","Severence",null,null,"C&C 25",14755,218,233,{"$f":"IF(T17 = \"s\",1000/(900+G17),\"\")","v":0.89445438282647582},{"$f":"IF(T17 =\"n\",1000/(900+H17),\"\")","v":""},{"$f":"IF(AK17>0,VLOOKUP($B17,'Finish Times'!$A$10:$G$40,6,FALSE),\"\")","v":""},{"$f":"IF(AK17>0,VLOOKUP($B17,'Finish Times'!$A$10:$G$40,7,FALSE),\"\")","v":""}," ","","","","","",null,"s","","",null,null,"","",null,6,"","","",null,null,54,9,null,{"$f":"VLOOKUP($B17,'Finish Times'!$A$10:$G$40,6,FALSE)","v":0}]
["Hull","Fools Game",null,null,"Pearson 26",1183,216,{"$f":"IFERROR(G18+15,\"\")","v":231},{"$f":"IF(T18 = \"s\",1000/(900+G18),\"\")","v":0.89605734767025091},{"$f":"IF(T18 =\"n\",1000/(900+H18),\"\")","v":""},{"$f":"IF(AK18>0,VLOOKUP($B18,'Finish Times'!$A$10:$G$40,6,FALSE),\"\")","v":97},{"$f":"IF(AK18>0,VLOOKUP($B18,'Finish Times'!$A$10:$G$40,7,FALSE),\"\")","v":46},97.766666666666666,87.60454002389487,6,42.635692671869947,5.6504024366565773,1274,null,"s",87.60454002389487,6,null,null,0.45996093438825358,44.968847352024923,null,9,6,42.635692671869947,5.6504024366565773,null,null,null,null,null,{"$f":"(VLOOKUP($B18,'Finish Times'!$A$10:$G$40,6,FALSE))","v":97}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K19>0,(K19+L19/60)-A$3,\" \")","v":" "},{"$f":"IFERROR(U19,\" \")","v":""},{"$f":"IFERROR(V19,\" \")","v":""},{"$f":"IFERROR(N19-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y19)-900,0),\"\")","v":""},null,"n","","",null,null,"","",null,10,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null," ","","","","","",null,"n","","",null,null,"","",null,11,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"n"," ","",null,null,"","",null,12,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K22>0,(K22+L22/60)-A$3,\" \")","v":" "},"","","","","",null,"n","","",null,null,"","",null,13,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null," ","","","","","",null,"n","","",null,null,"","",null,14,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null," ","","","","","",null,"n","","",null,null,"","",null,15,"","",""]
["Race Start Time ",null,null,null,null,null,null,null,null,null,null,null,null,"FLEET ONE",null,null,0,null,null,null,null,null,null,null,null,null,null,16,null,null,0]
["(In case race timer has issues, use clock time as backup and do the math)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,17,null,null,0]
["(1) Convert seconds to decimal equivalent - see reference sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,18,null,null,0]
["(2) Multiply time in minutes by circled TCF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,19,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["FLEET ONE",null,null,null,null,null,null,null,null,null,null,null,"RACE #"]

{"sheet":"Fleet 2","index":3,"n_rows":28,"n_cols":37,"rows_kept":28,"cut":false,"hidden":false,"merged":[[4,0,4,14],[6,0,6,14],[7,6,7,7],[7,8,7,9],[7,10,7,11],[5,5,5,8]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,"Winner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(N10:N22)","v":70.558002936857562}]
[{"$f":"'Finish Times'!B5","v":0},"<-----Minutes after first start"]
[]
["Blackwater Yacht Racing Association - Race Results - Fleet 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,"Test"]
[null,null,null,"Date:",{"$f":"'Finish Times'!I4","v":"2017-09-09"},{"$f":"'Finish Times'!I5","v":"2017 Fall Series Race #1"},null,null,null,null,{"$f":"CONCATENATE(\"RC:\",\" \",'Finish Times'!I6)","v":"RC: Maloney, Tunnell"},null,null,null,null,null,null,null,null,null,null,null,null,null,"new tcf =","should ="]
[{"$f":"'Finish Times'!I7","v":"Windward / Leeward Course 2X for Fleets I and II, 1X for Fleets III and IV "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time","Time","Approx",null,"Finish Calculations",null,null,null,null,"Winner Adj Time","Winner Adj Time",null,null,"# of Boats"]
[null,null,null,null,null,null,"Handicap",null,"TCF",null,"Finish Time",null,"Calc(1)","Adj.(2)",null,"Behind","Behind","H'cap",null,"S for Spin",null,null,null,null,"/observed",null,null,null,{"$f":"MAX(AC10:AC22)","v":3}]
["Skipper","Boat Name","Initials","Guest?","Boat","Sail #","Spin*","Non-Spin*","Spin*","Non-Spin*","Min.","Sec.","Min.dd","Time","Place","Winner","Boat Ahead","to win",null,"N for non"]
["Theis","Gotcha",null,null,"S-2 6.7",75,208,{"$f":"IFERROR(G10+15,\"\")","v":223},{"$f":"IF(T10 = \"s\",1000/(900+G10),\"\")","v":0.90252707581227432},{"$f":"IF(T10 =\"n\",1000/(900+H10),\"\")","v":""},{"$f":"IF(AK10>0,VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE),\"\")","v":""},{"$f":"IF(AK10>0,VLOOKUP($B10,'Finish Times'!$A$10:$G$40,7,FALSE),\"\")","v":""},{"$f":"IF(AK10>0,(K10+L10/60)-A$3,\" \")","v":" "},{"$f":"IFERROR(U10,\" \")","v":""},{"$f":"IFERROR(V10,\" \")","v":""},{"$f":"IFERROR(N10-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y10)-900,0),\"\")","v":""},null,"s",{"$f":"IFERROR(IF(M10>0,IF(T10=\"s\",M10*I10,0)+IF(T10=\"n\",M10*J10,0),\" \"),\"\")","v":""},{"$f":"IFERROR(RANK(N10,$N$10:$N$22,1),\"\")","v":""},null,null,{"$f":"IFERROR($Y$2/M10,\"\")","v":""},{"$f":"IFERROR(M10*Y10,\"\")","v":""},null,1,"","","",null,null,55,39,null,{"$f":"VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE)","v":0}]
["Firing","Fenix",null,null,"San Juan 24",556,218,{"$f":"IFERROR(G11+15,\"\")","v":233},{"$f":"IF(T11 = \"s\",1000/(900+G11),\"\")","v":0.89445438282647582},{"$f":"IF(T11 =\"n\",1000/(900+H11),\"\")","v":""},{"$f":"IF(AK11>0,VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE),\"\")","v":""},{"$f":"IF(AK11>0,VLOOKUP($B11,'Finish Times'!$A$10:$G$40,7,FALSE),\"\")","v":""}," ",{"$f":"IFERROR(U11,\" \")","v":""},{"$f":"IFERROR(V11,\" \")","v":""},{"$f":"IFERROR(N11-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y11)-900,0),\"\")","v":""},null,"s","","",null,null,"","",null,5,"","","",null,null,62,59,null,{"$f":"VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE)","v":0}]
["Whitt","Destiny",null,null,"Alerion 20",6,218,{"$f":"IFERROR(G12+15,\"\")","v":233},"",0.88261253309796994,{"$f":"IF(AK12>0,VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE),\"\")","v":82},{"$f":"IF(AK12>0,VLOOKUP($B12,'Finish Times'!$A$10:$G$40,7,FALSE),\"\")","v":25},82.416666666666671,{"$f":"IFERROR(U12,\" \")","v":72.741982936157697},{"$f":"IFERROR(V12,\" \")","v":2},{"$f":"IFERROR(N12-$Y$2,\"\")","v":2.183979999300135},2.183979999300135,{"$f":"IFERROR(ROUND((1000/Y12)-900,0),\"\")","v":268},null,"n",72.741982936157697,2,null,null,0.85611328133699771,70.558002936857562,null,6,2,2.183979999300135,2.183979999300135,null,null,59,12,null,{"$f":"VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE)","v":82}]
["Miekina","Synergy",null,null,"Harbor 20",215,220,{"$f":"IFERROR(G13+15,\"\")","v":235},{"$f":"IF(T13 = \"s\",1000/(900+G13),\"\")","v":""},{"$f":"IF(T13 =\"n\",1000/(900+H13),\"\")","v":0.88105726872246692},{"$f":"IF(AK13>0,VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE),\"\")","v":""},{"$f":"IF(AK13>0,VLOOKUP($B13,'Finish Times'!$A$10:$G$40,7,FALSE),\"\")","v":""}," ","","","","","",null,"n","","",null,null,"","",null,7,"","","",null,null,56,58,null,{"$f":"VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE)","v":0}]
["Hemler","Stoic",null,null,"Harbor 20",330,220,235,"",0.88105726872246692,{"$f":"IF(AK14>0,VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE),\"\")","v":80},{"$f":"IF(AK14>0,VLOOKUP($B14,'Finish Times'!$A$10:$G$40,7,FALSE),\"\")","v":5},80.083333333333329,70.558002936857562,1,0,null,235,null,"n",70.558002936857562,1,null,null,0.88105726872246704,70.558002936857562,null,8,1,0,null,null,null,64,47,null,{"$f":"VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE)","v":80}]
["Toone","StressLess",null,null,"Harbor 20",212,220,235,"",0.88105726872246692,{"$f":"IF(AK15>0,VLOOKUP($B15,'Finish Times'!$A$10:$G$40,6,FALSE),\"\")","v":82},{"$f":"IF(AK15>0,VLOOKUP($B15,'Finish Times'!$A$10:$G$40,7,FALSE),\"\")","v":58},82.966666666666669,73.098384728340676,3,2.5403817914831137,0.35640179218297874,276,null,"n",73.098384728340676,3,null,null,0.85043796227630652,70.558002936857562,null,9,3,2.5403817914831137,0.35640179218297874,null,null,null,null,null,{"$f":"VLOOKUP($B15,'Finish Times'!$A$10:$G$40,6,FALSE)","v":82}]
["Tunnell","Courageous",null,null,"Harbor 20",278,220,235,"",0.88105726872246692,{"$f":"IF(AK16>0,VLOOKUP($B16,'Finish Times'!$A$10:$G$40,6,FALSE),\"\")","v":""},{"$f":"IF(AK16>0,VLOOKUP($B16,'Finish Times'!$A$10:$G$40,7,FALSE),\"\")","v":""}," ","","","","","",null,"n","","",null,null,"","",null,10,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B16,'Finish Times'!$A$10:$G$40,6,FALSE)","v":0}]
[null,null,null,null,null,null,null,null,null,"",null,null,null," ","","","","",null,"s"," ","",null,null,"","",null,11,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B17,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(U18,\" \")","v":" "},"",{"$f":"IFERROR(N18-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y18)-900,0),\"\")","v":""},null,"s"," ","",null,null,"","",null,12,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B18,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","",{"$f":"IFERROR(N19-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y19)-900,0),\"\")","v":""},null,"n"," ","",null,null,"","",null,13,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B19,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","",{"$f":"IFERROR(N20-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y20)-900,0),\"\")","v":""},null,"n"," ","",null,null,"","",null,14,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B20,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","",{"$f":"IFERROR(N21-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y21)-900,0),\"\")","v":""},null,"n"," ","",null,null,"","",null,15,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B21,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","",{"$f":"IFERROR(N22-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y22)-900,0),\"\")","v":""},null,"n"," ","",null,null,"","",null,null,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B22,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
["Race Start Time ",null,null,null,null,null,null,null,null,null,null,null,null,"FLEET TWO",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["(In case race timer has issues, use clock time as backup and do the math)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["(1) Convert seconds to decimal equivalent - see reference sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["(2) Multiply time in minutes by circled TCF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["FLEET TWO",null,null,null,null,null,null,null,null,null,null,null,"RACE #",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Fleet 3","index":4,"n_rows":30,"n_cols":37,"rows_kept":30,"cut":false,"hidden":false,"merged":[[4,0,4,14],[6,0,6,14],[7,6,7,7],[7,8,7,9],[7,10,7,11],[5,5,5,8]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,"Winner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(N10:N24)","v":68.820468343451864}]
[{"$f":"'Finish Times'!B6","v":5},"<-----Minutes after first start"]
[]
["Blackwater Yacht Racing Association - Race Results - Fleet 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test"]
[null,null,null,null,{"$f":"'Finish Times'!I4","v":"2017-09-09"},{"$f":"'Finish Times'!I5","v":"2017 Fall Series Race #1"},null,null,null,null,{"$f":"CONCATENATE(\"RC:\",\" \",'Finish Times'!I6)","v":"RC: Maloney, Tunnell"},null,null,null,null,null,null,null,null,null,null,null,null,null,"new tcf =","should ="]
[{"$f":"'Finish Times'!I7","v":"Windward / Leeward Course 2X for Fleets I and II, 1X for Fleets III and IV "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time","Time","Approx",null,"Finish Calculations",null,null,null,null,"Winner Adj Time","Winner Adj Time",null,null,"# of Boats"]
[null,null,null,null,null,null,"Handicap",null,"TCF",null,"Finish Time",null,"Calc(1)","Adj.(2)",null,"Behind","Behind","H'cap",null,"S for Spin",null,null,null,null,"/observed",null,null,null,{"$f":"MAX(AC10:AC24)","v":3}]
["Skipper","Boat Name","Initials","Guest?","Boat","Sail #","Spin*","Non-Spin*","Spin*","Non-Spin*","Min.","Sec.","Min.dd","Time","Place","Winner","Boat Ahead","to win",null,"N for non"]
["Perdue","Miss Virginia",null,null,"Hunter 23.5",1309,243,{"$f":"IFERROR(G10+15,\"\")","v":258},{"$f":"IF(T10 = \"s\",1000/(900+G10),\"\")","v":0.87489063867016625},{"$f":"IF(T10 =\"n\",1000/(900+H10),\"\")","v":""},{"$f":"IF(AK10>0,VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE),\" \")","v":" "},{"$f":"IF(AK10>0,VLOOKUP($B10,'Finish Times'!$A$10:$G$40,7,FALSE),\" \")","v":" "},{"$f":"IF(AK10>0,(K10+L10/60)-A$3,\" \")","v":" "},{"$f":"IFERROR(U10,\" \")","v":""},"",{"$f":"IFERROR(N10-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y10)-900,0),\"\")","v":""},null,"s",{"$f":"IFERROR(IF(M10>0,IF(T10=\"s\",M10*I10,0)+IF(T10=\"n\",M10*J10,0),\" \"),\"\")","v":""},{"$f":"IFERROR(RANK(N10,$N$10:$N$24,1),\"\")","v":""},null,null,{"$f":"IFERROR($Y$2/M10,\"\")","v":""},{"$f":"IFERROR(M10*Y10,\"\")","v":""},null,1,"","","",null,null,55,39,null,{"$f":"VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE)","v":0}]
["Schraw","Second Wind",null,null,"Ericson 23",470,241,{"$f":"IFERROR(G11+15,\"\")","v":256},{"$f":"IF(T11 = \"s\",1000/(900+G11),\"\")","v":""},{"$f":"IF(T11 =\"n\",1000/(900+H11),\"\")","v":0.86505190311418689},{"$f":"IF(AK11>0,VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE),\" \")","v":100},{"$f":"IF(AK11>0,VLOOKUP($B11,'Finish Times'!$A$10:$G$40,7,FALSE),\" \")","v":19},{"$f":"IF(AK11>0,(K11+L11/60)-A$3,\" \")","v":95.316666666666663},82.453863898500572,3,13.633395555048708,0.66054207927201958,485,null,"n",{"$f":"IFERROR(IF(M11>0,IF(T11=\"s\",M11*I11,0)+IF(T11=\"n\",M11*J11,0),\" \"),\"\")","v":82.453863898500572},{"$f":"IFERROR(RANK(N11,$N$10:$N$24,1),\"\")","v":3},null,null,0.72201925172357262,{"$f":"IFERROR(M11*Y11,\"\")","v":68.820468343451864},null,2,3,13.633395555048708,0.66054207927201958,null,null,56,22,null,{"$f":"VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE)","v":100}]
["Short","Fever",null,null,"Ericson 23",269,{"$f":"241+3","v":244},259,{"$f":"IF(T12 = \"s\",1000/(900+G12),\"\")","v":""},{"$f":"IF(T12 =\"n\",1000/(900+H12),\"\")","v":0.86281276962899056},{"$f":"IF(AK12>0,VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE),\" \")","v":" "},{"$f":"IF(AK12>0,VLOOKUP($B12,'Finish Times'!$A$10:$G$40,7,FALSE),\" \")","v":" "}," ","","","","","",null,"n","","",null,null,"","",null,3,"","","",null,null,54,9,null,{"$f":"VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE)","v":0}]
["Gobble","Always Something",null,null,"Hunter 23",1256,243,258,{"$f":"IF(T13 = \"s\",1000/(900+G13),\"\")","v":""},{"$f":"IF(T13 =\"n\",1000/(900+H13),\"\")","v":0.86355785837651122},{"$f":"IF(AK13>0,VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE),\" \")","v":99},{"$f":"IF(AK13>0,VLOOKUP($B13,'Finish Times'!$A$10:$G$40,7,FALSE),\" \")","v":43},94.716666666666669,81.793321819228552,2,12.972853475776688,12.972853475776688,476,null,"n",81.793321819228552,2,null,null,0.72659301435986479,68.820468343451864,null,4,2,12.972853475776688,12.972853475776688,null,null,62,59,null,{"$f":"VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE)","v":99}]
["Perdue","Debra Ann",null,null,"O'Day 25 CB",13092,238,253,{"$f":"IF(T14 = \"s\",1000/(900+G14),\"\")","v":""},{"$f":"IF(T14 =\"n\",1000/(900+H14),\"\")","v":0.86730268863833482},{"$f":"IF(AK14>0,VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE),\" \")","v":84},{"$f":"IF(AK14>0,VLOOKUP($B14,'Finish Times'!$A$10:$G$40,7,FALSE),\" \")","v":21},79.349999999999994,68.820468343451864,1,0,null,253,null,"n",68.820468343451864,1,null,null,0.86730268863833482,68.820468343451864,null,5,1,0,null,null,null,59,12,null,{"$f":"VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE)","v":84}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(U15,\" \")","v":" "},{"$f":"IFERROR(V15,\" \")","v":""},{"$f":"IFERROR(N15-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y15)-900,0),\"\")","v":""},null,"n"," ","",null,null,"","",null,6,"","","",null,null,56,58,null,{"$f":"VLOOKUP($B15,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,7,"","","",null,null,64,47,null,{"$f":"VLOOKUP($B16,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,8,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B17,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,9,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B18,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,10,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B19,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"s"," ","",null,null,"","",null,11,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B20,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,12,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B21,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,13,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B22,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,14,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B23,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,15,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B24,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
["Race Start Time ",null,null,null,null,null,null,null,null,null,null,null,null,"FLEET THREE",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["(In case race timer has issues, use clock time as backup and do the math)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["(1) Convert seconds to decimal equivalent - see reference sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["(2) Multiply time in minutes by circled TCF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["FLEET THREE",null,null,null,null,null,null,null,null,null,null,null,"RACE #"]

{"sheet":"Fleet 4","index":5,"n_rows":29,"n_cols":37,"rows_kept":29,"cut":false,"hidden":false,"merged":[[4,0,4,14],[6,0,6,14],[7,6,7,7],[7,8,7,9],[7,10,7,11],[5,5,5,8]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,"Winner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(N10:N23)","v":67.644483362521896}]
[{"$f":"'Finish Times'!B7","v":5},"<-----Minutes after first start"]
[]
["Blackwater Yacht Racing Association - Race Results - Fleet 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test"]
[null,null,null,"Date:",{"$f":"'Finish Times'!I4","v":"2017-09-09"},{"$f":"'Finish Times'!I5","v":"2017 Fall Series Race #1"},null,null,null,null,{"$f":"CONCATENATE(\"RC:\",\" \",'Finish Times'!I6)","v":"RC: Maloney, Tunnell"},null,null,null,null,null,null,null,null,null,null,null,null,null,"new tcf =","should ="]
[{"$f":"'Finish Times'!I7","v":"Windward / Leeward Course 2X for Fleets I and II, 1X for Fleets III and IV "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time","Time","Approx",null,"Finish Calculations",null,null,null,null,"Winner Adj Time","Winner Adj Time",null,null,"# of Boats"]
[null,null,null,null,null,null,"Handicap",null,"TCF",null,"Finish Time",null,"Calc(1)","Adj.(2)",null,"Behind","Behind","H'cap",null,"S for Spin",null,null,null,null,"/observed",null,null,null,{"$f":"MAX(AC10:AC23)","v":3}]
["Skipper","Boat Name","Initials","Guest?","Boat","Sail #","Spin*","Non-Spin*","Spin*","Non-Spin*","Min.","Sec.","Min.dd","Time","Place","Winner","Boat Ahead","to win",null,"N for non"]
["DeMestro","Little Wing",null,null,"Beneteau 29",485,168,{"$f":"IFERROR(G10+15,\"\")","v":183},{"$f":"IF(T10 = \"s\",1000/(900+G10),\"\")","v":""},{"$f":"IF(T10 =\"n\",1000/(900+H10),\"\")","v":0.92336103416435822},{"$f":"IF(AK10>0,VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE),\" \")","v":" "},{"$f":"IF(AK10>0,VLOOKUP($B10,'Finish Times'!$A$10:$G$40,7,FALSE),\" \")","v":" "},{"$f":"IF(AK10>0,(K10+L10/60)-A$3,\" \")","v":" "},{"$f":"IFERROR(U10,\" \")","v":""},"",{"$f":"IFERROR(N10-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y10)-900,0),\"\")","v":""},null,"n",{"$f":"IFERROR(IF(M10>0,IF(T10=\"s\",M10*I10,0)+IF(T10=\"n\",M10*J10,0),\" \"),\"\")","v":""},{"$f":"IFERROR(RANK(N10,$N$10:$N$23,1),\"\")","v":""},null,null,{"$f":"IFERROR($Y$2/M10,\"\")","v":""},{"$f":"IFERROR(M10*Y10,\"\")","v":""},null,1,"","","",null,null,55,39,null,{"$f":"VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE)","v":0}]
["Oginz","Alarming",null,null,"S-2 9.2",505,{"$f":"183+3+3","v":189},{"$f":"IFERROR(G11+15,\"\")","v":204},{"$f":"IF(T11 = \"s\",1000/(900+G11),\"\")","v":""},{"$f":"IF(T11 =\"n\",1000/(900+H11),\"\")","v":0.90579710144927539},{"$f":"IF(AK11>0,VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE),\" \")","v":100},{"$f":"IF(AK11>0,VLOOKUP($B11,'Finish Times'!$A$10:$G$40,7,FALSE),\" \")","v":29},{"$f":"IF(AK11>0,(K11+L11/60)-A$3,\" \")","v":95.483333333333334},86.488526570048307,2,18.844043207526411,18.844043207526411,512,null,"n",{"$f":"IFERROR(IF(M11>0,IF(T11=\"s\",M11*I11,0)+IF(T11=\"n\",M11*J11,0),\" \"),\"\")","v":86.488526570048307},2,null,null,0.70844283500633853,{"$f":"IFERROR(M11*Y11,\"\")","v":67.644483362521896},null,2,2,18.844043207526411,18.844043207526411,null,null,56,22,null,{"$f":"VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE)","v":100}]
["Gearhart","More Mischief",null,null,"Beneteau 285",144,{"$f":"193+6","v":199},214,{"$f":"IF(T12 = \"s\",1000/(900+G12),\"\")","v":""},{"$f":"IF(T12 =\"n\",1000/(900+H12),\"\")","v":0.89766606822262118},{"$f":"IF(AK12>0,VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE),\" \")","v":" "},{"$f":"IF(AK12>0,VLOOKUP($B12,'Finish Times'!$A$10:$G$40,7,FALSE),\" \")","v":" "}," ","","","","","",null,"n","","",null,null,"","",null,4,"","","",null,null,62,59,null,{"$f":"VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE)","v":0}]
["Johnson","Felicite",null,null,"S-2 27 IB",13,{"$f":"188+6","v":194},209,{"$f":"IF(T13 = \"s\",1000/(900+G13),\"\")","v":""},{"$f":"IF(T13 =\"n\",1000/(900+H13),\"\")","v":0.90171325518485124},{"$f":"IF(AK13>0,VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE),\" \")","v":101},{"$f":"IF(AK13>0,VLOOKUP($B13,'Finish Times'!$A$10:$G$40,7,FALSE),\" \")","v":34},96.566666666666663,87.075443342350468,3,19.430959979828572,0.58691677230216044,528,null,"n",87.075443342350468,3,null,null,0.70049516771683018,67.644483362521896,null,5,3,19.430959979828572,0.58691677230216044,null,null,59,12,null,{"$f":"VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE)","v":101}]
["Conover","Willawaw",null,null,"Columbia 29",222,227,{"$f":"IFERROR(G14+15,\"\")","v":242},{"$f":"IF(T14 = \"s\",1000/(900+G14),\"\")","v":""},{"$f":"IF(T14 =\"n\",1000/(900+H14),\"\")","v":0.87565674255691772},{"$f":"IF(AK14>0,VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE),\" \")","v":82},{"$f":"IF(AK14>0,VLOOKUP($B14,'Finish Times'!$A$10:$G$40,7,FALSE),\" \")","v":15},77.25,{"$f":"IFERROR(U14,\" \")","v":67.644483362521896},{"$f":"IFERROR(V14,\" \")","v":1},{"$f":"IFERROR(N14-$Y$2,\"\")","v":0},null,{"$f":"IFERROR(ROUND((1000/Y14)-900,0),\"\")","v":242},null,"n",67.644483362521896,1,null,null,0.87565674255691772,67.644483362521896,null,6,1,0,null,null,null,56,58,null,{"$f":"VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE)","v":82}]
["Gillespie","Ie Ie Bang Bang",null,null,"Hunter 365",8,148,163,null,0.94073377234242705,null,{"$f":"IF(AK15>0,VLOOKUP($B15,'Finish Times'!$A$10:$G$40,7,FALSE),\" \")","v":" "}," ","","","","","",null,"n","","",null,null,"","",null,7,"","","",null,null,64,47,null,{"$f":"VLOOKUP($B15,'Finish Times'!$A$10:$G$40,6,FALSE)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(U16,\" \")","v":" "},{"$f":"IFERROR(V16,\" \")","v":""},{"$f":"IFERROR(N16-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y16)-900,0),\"\")","v":""},null,"n"," ","",null,null,"","",null,8,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B16,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,9,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B17,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,10,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B18,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,11,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B19,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,12,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B20,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,13,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B21,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,14,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B22,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,15,"","","",null,null,null,null,null,{"$f":"VLOOKUP($B23,'Finish Times'!$A$10:$G$40,6,FALSE)","v":{"$error":"#N/A"}}]
["Race Start Time ",null,null,null,null,null,null,null,null,null,null,null,null,"FLEET FOUR",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["(In case race timer has issues, use clock time as backup and do the math)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["(1) Convert seconds to decimal equivalent - see reference sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["(2) Multiply time in minutes by circled TCF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["FLEET FOUR",null,null,null,null,null,null,null,null,null,null,null,"RACE #"]

{"sheet":"Fleet 1 and 2 Combo","index":6,"n_rows":33,"n_cols":37,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,0,4,14],[6,0,6,14],[7,6,7,7],[7,8,7,9],[7,10,7,11],[5,5,5,8]]}
["Control Z to run macro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,"Winner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(N10:N27)","v":44.968847352024923}]
[{"$f":"'Finish Times'!B4","v":0},"<-----Minutes after first start"]
[]
["Blackwater Yacht Racing Association - Race Results Fleets I & 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test"]
[null,null,null,"Date:",{"$f":"'Finish Times'!I4","v":"2017-09-09"},{"$f":"'Finish Times'!I5","v":"2017 Fall Series Race #1"},null,null,null,null,{"$f":"CONCATENATE(\"RC:\",\" \",'Finish Times'!I6)","v":"RC: Maloney, Tunnell"},null,null,null,null,null,null,null,null,null,null,null,null,null,"new tcf =","should ="]
[{"$f":"'Finish Times'!I7","v":"Windward / Leeward Course 2X for Fleets I and II, 1X for Fleets III and IV "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time","Time","Approx",null,"Finish Calculations",null,null,null,null,"Winner Adj Time","Winner Adj Time",null,null,"# of Boats"]
[null,null,null,null,null,null,"Handicap",null,"TCF",null,"Finish Time",null,"Calc(1)","Adj.(2)",null,"Behind","Behind","H'cap",null,"S for Spin",null,null,null,null,"/observed",null,null,null,{"$f":"MAX(AC10:AC27)","v":9}]
["Skipper","Boat Name","Initials","Guest?","Boat","Sail #","Spin*","Non-Spin*","Spin*","Non-Spin*","Min.","Sec.","Min.dd","Time","Place","Winner","Boat Ahead","to win",null,"N for non"]
["Cliborne","Bandit",null,null,"J/24",2792,170,{"$f":"IFERROR(G10+15,\"\")","v":185},{"$f":"IF(T10 = \"s\",1000/(900+G10),\"\")","v":0.93457943925233644},{"$f":"IF(T10 =\"n\",1000/(900+H10),\"\")","v":""},{"$f":"IF($AK10>0,(VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":48},{"$f":"IF($AK10>0,(VLOOKUP($B10,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":7},{"$f":"IF(AK10>0,(K10+L10/60)-A$3,\" \")","v":48.116666666666667},{"$f":"IFERROR(U10,\" \")","v":44.968847352024923},1,{"$f":"IFERROR(N10-$Y$2,\"\")","v":0},null,{"$f":"IFERROR(ROUND((1000/Y10)-900,0),\"\")","v":170},null,"s",{"$f":"IFERROR(IF(M10>0,IF(T10=\"s\",M10*I10,0)+IF(T10=\"n\",M10*J10,0),\" \"),\"\")","v":44.968847352024923},{"$f":"IFERROR(RANK(N10,$N$10:$N$27,1),\"\")","v":1},null,null,{"$f":"IFERROR($Y$2/M10,\"\")","v":0.93457943925233644},{"$f":"IFERROR(M10*Y10,\"\")","v":44.968847352024923},null,1,1,0,null,null,null,55,39,null,{"$f":"(VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE))","v":48}]
["Forqurean","Dark Horse",null,null,"J/24",1024,170,185,0.93457943925233644,{"$f":"IF(T11 =\"n\",1000/(900+H11),\"\")","v":""},{"$f":"IF($AK11>0,(VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":78},{"$f":"IF($AK11>0,(VLOOKUP($B11,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":34},{"$f":"IF(AK11>0,(K11+L11/60)-A$3,\" \")","v":78.566666666666663},73.426791277258559,6,28.457943925233636,0.3284065489178829,847,null,"s",{"$f":"IFERROR(IF(M11>0,IF(T11=\"s\",M11*I11,0)+IF(T11=\"n\",M11*J11,0),\" \"),\"\")","v":73.426791277258559},6,null,null,0.5723654732968807,{"$f":"IFERROR(M11*Y11,\"\")","v":44.968847352024923},null,2,6,28.457943925233636,0.3284065489178829,null,null,56,22,null,{"$f":"(VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE))","v":78}]
["Maloney","Boogie Board",null,null,"J/24",1742,170,185,0.93457943925233644,{"$f":"IF(T12 =\"n\",1000/(900+H12),\"\")","v":""},{"$f":"IF($AK12>0,(VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK12>0,(VLOOKUP($B12,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""}," ","","","","","",null,"s","","",null,null,"","",null,3,"","","",null,null,54,9,null,{"$f":"(VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["Phillip","Rascal",null,null,"J/24",3511,170,185,0.93457943925233644,{"$f":"IF(T13 =\"n\",1000/(900+H13),\"\")","v":""},{"$f":"IF($AK13>0,(VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":63},{"$f":"IF($AK13>0,(VLOOKUP($B13,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":25},63.416666666666664,59.267912772585667,2,14.299065420560744,14.299065420560744,510,null,"s",59.267912772585667,2,null,null,0.7091014037112997,44.968847352024923,null,4,2,14.299065420560744,14.299065420560744,null,null,62,59,null,{"$f":"(VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE))","v":63}]
["Sampson","Time Warp",null,null,"J/24",1248,170,185,0.93457943925233644,{"$f":"IF(T14 =\"n\",1000/(900+H14),\"\")","v":""},{"$f":"IF($AK14>0,(VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK14>0,(VLOOKUP($B14,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""}," ","","","","","",null,"s","","",null,null,"","",null,5,"","","",null,null,59,12,null,{"$f":"(VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["Schiable","Catch 22",null,null,"J22",826,177,{"$f":"IFERROR(G15+15,\"\")","v":192},{"$f":"IF(T15 = \"s\",1000/(900+G15),\"\")","v":0.92850510677808729},{"$f":"IF(T15 =\"n\",1000/(900+H15),\"\")","v":""},{"$f":"IF($AK15>0,(VLOOKUP($B15,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":82},{"$f":"IF($AK15>0,(VLOOKUP($B15,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":22},{"$f":"IF(AK15>0,(K15+L15/60)-A$3,\" \")","v":82.36666666666666},{"$f":"IFERROR(U15,\" \")","v":76.477870628288457},7,{"$f":"IFERROR(N15-$Y$2,\"\")","v":31.509023276263534},3.0510793510298981,{"$f":"IFERROR(ROUND((1000/Y15)-900,0),\"\")","v":932},null,"s",76.477870628288457,7,null,null,0.54595929605857862,44.968847352024923,null,6,7,31.509023276263534,3.0510793510298981,null,null,56,58,null,{"$f":"(VLOOKUP($B15,'Finish Times'!$A$10:$G$40,6,FALSE))","v":82}]
["Gietl","UDO",null,null,"VX One",119,103,118,0.99700897308075775,"",{"$f":"IF($AK16>0,(VLOOKUP($B16,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":82},{"$f":"IF($AK16>0,(VLOOKUP($B16,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":12},82.2,81.954137587238293,8,36.98529023521337,36.98529023521337,928,null,"s",81.954137587238293,8,null,null,0.54706626948935433,44.96884735202493,null,7,8,36.98529023521337,36.98529023521337,null,null,64,47,null,{"$f":"(VLOOKUP($B16,'Finish Times'!$A$10:$G$40,6,FALSE))","v":82}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"s"," ","",null,null,"","",null,9,"",null,-31.509023276263534,null,null,null,null,null,{"$f":"(VLOOKUP($B17,'Finish Times'!$A$10:$G$40,6,FALSE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",null,"s"," ","",null,null,"","",null,10,"",null,0,null,null,null,null,null,{"$f":"(VLOOKUP($B18,'Finish Times'!$A$10:$G$40,6,FALSE))","v":{"$error":"#N/A"}}]
["Theis","Gotcha",null,null,"S-2 6.7",75,208,{"$f":"IFERROR(G19+15,\"\")","v":223},{"$f":"IF(T19 = \"s\",1000/(900+G19),\"\")","v":0.90252707581227432},{"$f":"IF(T19 =\"n\",1000/(900+H19),\"\")","v":""},{"$f":"IF($AK19>0,(VLOOKUP($B19,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK19>0,(VLOOKUP($B19,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""},{"$f":"IF(AK19>0,(K19+L19/60)-A$3,\" \")","v":" "},{"$f":"IFERROR(U19,\" \")","v":""},"",{"$f":"IFERROR(N19-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y19)-900,0),\"\")","v":""},null,"s","","",null,null,"","",null,11,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B19,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["Hull","Fools Game",null,null,"Pearson 26",1183,216,231,0.89605734767025091,"",{"$f":"IF($AK20>0,(VLOOKUP($B20,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":97},{"$f":"IF($AK20>0,(VLOOKUP($B20,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":46},97.766666666666666,87.60454002389487,9,42.635692671869947,5.6504024366565773,1274,null,"s",87.60454002389487,9,null,null,0.45996093438825358,44.968847352024923,null,12,9,42.635692671869947,5.6504024366565773,null,null,null,null,null,{"$f":"(VLOOKUP($B20,'Finish Times'!$A$10:$G$40,6,FALSE))","v":97}]
["Evans","Severence",null,null,"C&C 25",14755,218,233,0.89445438282647582,"",{"$f":"IF($AK21>0,(VLOOKUP($B21,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK21>0,(VLOOKUP($B21,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""}," ","","","","","",null,"s","","",null,null,"","",null,13,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B21,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["Firing","Fenix",null,null,"San Juan 24",556,218,233,0.89445438282647582,"",{"$f":"IF(AK22>0,VLOOKUP($B22,'Finish Times'!$A$10:$G$40,6,FALSE),\"\")","v":""},{"$f":"IF(AK22>0,VLOOKUP($B22,'Finish Times'!$A$10:$G$40,7,FALSE),\"\")","v":""}," ","","","","","",null,"s","","",null,null,"",null,null,14,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B22,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["Whitt","Destiny",null,null,"Alerion 20",6,218,233,"",0.88261253309796994,{"$f":"IF($AK23>0,(VLOOKUP($B23,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":82},{"$f":"IF($AK23>0,(VLOOKUP($B23,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":25},{"$f":"IF(AK23>0,(K23+L23/60)-A$3,\" \")","v":82.416666666666671},{"$f":"IFERROR(U23,\" \")","v":72.741982936157697},4,{"$f":"IFERROR(N23-$Y$2,\"\")","v":27.773135584132774},2.183979999300135,{"$f":"IFERROR(ROUND((1000/Y23)-900,0),\"\")","v":933},null,"n",72.741982936157697,4,null,null,0.54562807707209204,null,null,15,4,27.773135584132774,2.183979999300135,null,null,null,null,null,{"$f":"(VLOOKUP($B23,'Finish Times'!$A$10:$G$40,6,FALSE))","v":82}]
["Miekina","Synergy",null,null,"Harbor 20",215,220,{"$f":"IFERROR(G24+15,\"\")","v":235},{"$f":"IF(T24 = \"s\",1000/(900+G24),\"\")","v":""},{"$f":"IF(T24 =\"n\",1000/(900+H24),\"\")","v":0.88105726872246692},{"$f":"IF($AK24>0,(VLOOKUP($B24,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK24>0,(VLOOKUP($B24,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""}," ","","","","","",null,"n","","",null,null,"",null,null,16,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B24,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["Hemler","Stoic",null,null,"Harbor 20",330,220,235,"",0.88105726872246692,{"$f":"IF($AK25>0,(VLOOKUP($B25,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":80},{"$f":"IF($AK25>0,(VLOOKUP($B25,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":5},80.083333333333329,70.558002936857562,3,25.589155584832639,11.290090164271895,881,null,"n",70.558002936857562,3,null,null,0.56152566932809478,null,null,17,3,25.589155584832639,11.290090164271895,null,null,null,null,null,{"$f":"(VLOOKUP($B25,'Finish Times'!$A$10:$G$40,6,FALSE))","v":80}]
["Toone","StressLess",null,null,"Harbor 20",212,220,235,"",0.88105726872246692,{"$f":"IF($AK26>0,(VLOOKUP($B26,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":82},{"$f":"IF($AK26>0,(VLOOKUP($B26,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":58},82.966666666666669,73.098384728340676,5,28.129537376315753,0.35640179218297874,945,null,"n",73.098384728340676,5,null,null,0.5420110166977693,44.96884735202493,null,18,5,28.129537376315753,0.35640179218297874,null,null,null,null,null,{"$f":"(VLOOKUP($B26,'Finish Times'!$A$10:$G$40,6,FALSE))","v":82}]
["Tunnell","Courageous",null,null,"Harbor 20",278,220,235,"",0.88105726872246692,{"$f":"IF($AK27>0,(VLOOKUP($B27,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK27>0,(VLOOKUP($B27,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""}," ","","","","","",null,"n","","",null,null,"","",null,19,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B27,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,20,null,null,""]
["(In case race timer has issues, use clock time as backup and do the math)"]
["(1) Convert seconds to decimal equivalent - see reference sheet"]
["(2) Multiply time in minutes by circled TCF"]
[]
["FLEET ONE",null,null,null,null,null,null,null,null,null,null,null,"RACE #"]

{"sheet":"Fleet 3 and 4 Combo","index":7,"n_rows":29,"n_cols":37,"rows_kept":29,"cut":false,"hidden":false,"merged":[[4,0,4,14],[6,0,6,14],[7,6,7,7],[7,8,7,9],[7,10,7,11],[5,5,5,8]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,"Winner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(N10:N23)","v":67.644483362521896}]
[{"$f":"'Finish Times'!B6","v":5},"<-----Minutes after first start"]
[]
["Blackwater Yacht Racing Association - Race Results Fleets 3 & 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test"]
[null,null,null,"Date:",{"$f":"'Finish Times'!I4","v":"2017-09-09"},{"$f":"'Finish Times'!I5","v":"2017 Fall Series Race #1"},null,null,null,null,{"$f":"CONCATENATE(\"RC:\",\" \",'Finish Times'!I6)","v":"RC: Maloney, Tunnell"},null,null,null,null,null,null,null,null,null,null,null,null,null,"new tcf =","should ="]
[{"$f":"'Finish Times'!I7","v":"Windward / Leeward Course 2X for Fleets I and II, 1X for Fleets III and IV "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time","Time","Approx",null,"Finish Calculations",null,null,null,null,"Winner Adj Time","Winner Adj Time",null,null,"# of Boats"]
[null,null,null,null,null,null,"Handicap",null,"TCF",null,"Finish Time",null,"Calc(1)","Adj.(2)",null,"Behind","Behind","H'cap",null,"S for Spin",null,null,null,null,"/observed",null,null,null,{"$f":"MAX(AC10:AC23)","v":6}]
["Skipper","Boat Name","Initials","Guest?","Boat","Sail #","Spin*","Non-Spin*","Spin*","Non-Spin*","Min.","Sec.","Min.dd","Time","Place","Winner","Boat Ahead","to win",null,"N for non"]
["Perdue","Miss Virginia",null,null,"Hunter 23.5",1309,243,{"$f":"IFERROR(G10+15,\"\")","v":258},{"$f":"IF(T10 = \"s\",1000/(900+G10),\"\")","v":0.87489063867016625},{"$f":"IF(T10 =\"n\",1000/(900+H10),\"\")","v":""},{"$f":"IF($AK10>0,(VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK10>0,(VLOOKUP($B10,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""},{"$f":"IF(AK10>0,(K10+L10/60)-A$3,\" \")","v":" "},{"$f":"IFERROR(U10,\" \")","v":""},"",{"$f":"IFERROR(N10-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y10)-900,0),\"\")","v":""},null,"s",{"$f":"IFERROR(IF(M10>0,IF(T10=\"s\",M10*I10,0)+IF(T10=\"n\",M10*J10,0),\" \"),\"\")","v":""},{"$f":"IFERROR(RANK(N10,$N$10:$N$23,1),\"\")","v":""},null,null,{"$f":"IFERROR($Y$2/M10,\"\")","v":""},{"$f":"IFERROR(M10*Y10,\"\")","v":""},null,1,"","","",null,null,55,39,null,{"$f":"(VLOOKUP($B10,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["Schraw","Second Wind",null,null,"Ericson 23",470,241,{"$f":"IFERROR(G11+15,\"\")","v":256},{"$f":"IF(T11 = \"s\",1000/(900+G11),\"\")","v":""},{"$f":"IF(T11 =\"n\",1000/(900+H11),\"\")","v":0.86505190311418689},{"$f":"IF($AK11>0,(VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":100},{"$f":"IF($AK11>0,(VLOOKUP($B11,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":19},95.316666666666663,82.453863898500572,4,14.809380535978676,0.66054207927201958,509,null,"n",{"$f":"IFERROR(IF(M11>0,IF(T11=\"s\",M11*I11,0)+IF(T11=\"n\",M11*J11,0),\" \"),\"\")","v":82.453863898500572},4,null,null,0.70968158799638292,{"$f":"IFERROR(M11*Y11,\"\")","v":67.644483362521896},null,2,4,14.809380535978676,0.66054207927201958,null,null,56,22,null,{"$f":"(VLOOKUP($B11,'Finish Times'!$A$10:$G$40,6,FALSE))","v":100}]
["Short","Fever",null,null,"Ericson 23",269,{"$f":"241+3","v":244},259,{"$f":"IF(T12 = \"s\",1000/(900+G12),\"\")","v":""},{"$f":"IF(T12 =\"n\",1000/(900+H12),\"\")","v":0.86281276962899056},{"$f":"IF($AK12>0,(VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK12>0,(VLOOKUP($B12,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""},{"$f":"IF(AK12>0,(K12+L12/60)-A$3,\" \")","v":" "},{"$f":"IFERROR(U12,\" \")","v":""},{"$f":"IFERROR(V12,\" \")","v":""},{"$f":"IFERROR(N12-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y12)-900,0),\"\")","v":""},null,"n","","",null,null,"","",null,3,"","","",null,null,54,9,null,{"$f":"(VLOOKUP($B12,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["Gobble","Always Something",null,null,"Hunter 23",1256,243,258,{"$f":"IF(T13 = \"s\",1000/(900+G13),\"\")","v":""},{"$f":"IF(T13 =\"n\",1000/(900+H13),\"\")","v":0.86355785837651122},{"$f":"IF($AK13>0,(VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":99},{"$f":"IF($AK13>0,(VLOOKUP($B13,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":43},94.716666666666669,81.793321819228552,3,14.148838456706656,12.972853475776688,500,null,"n",81.793321819228552,3,null,null,0.71417719545157732,67.644483362521896,null,4,3,14.148838456706656,12.972853475776688,null,null,62,59,null,{"$f":"(VLOOKUP($B13,'Finish Times'!$A$10:$G$40,6,FALSE))","v":99}]
["Perdue","Debra Ann",null,null,"O'Day 25 CB",13092,238,253,{"$f":"IF(T14 = \"s\",1000/(900+G14),\"\")","v":""},{"$f":"IF(T14 =\"n\",1000/(900+H14),\"\")","v":0.86730268863833482},{"$f":"IF($AK14>0,(VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":84},{"$f":"IF($AK14>0,(VLOOKUP($B14,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":21},79.349999999999994,68.820468343451864,2,1.1759849809299681,1.1759849809299681,273,null,"n",68.820468343451864,2,null,null,0.85248246203556266,67.644483362521896,null,5,2,1.1759849809299681,1.1759849809299681,null,null,59,12,null,{"$f":"(VLOOKUP($B14,'Finish Times'!$A$10:$G$40,6,FALSE))","v":84}]
["DeMestro","Little Wing",null,null,"Beneteau 29",485,168,{"$f":"IFERROR(G15+15,\"\")","v":183},{"$f":"IF(T15 = \"s\",1000/(900+G15),\"\")","v":""},{"$f":"IF(T15 =\"n\",1000/(900+H15),\"\")","v":0.92336103416435822},{"$f":"IF($AK15>0,(VLOOKUP($B15,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK15>0,(VLOOKUP($B15,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""}," ",{"$f":"IFERROR(U15,\" \")","v":""},{"$f":"IFERROR(V15,\" \")","v":""},{"$f":"IFERROR(N15-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y15)-900,0),\"\")","v":""},null,"n","","",null,null,"","",null,6,"","","",null,null,56,58,null,{"$f":"(VLOOKUP($B15,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["Oginz","Alarming",null,null,"S-2 9.2",505,{"$f":"183+3+3","v":189},204,"",0.90579710144927539,{"$f":"IF($AK16>0,(VLOOKUP($B16,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":100},{"$f":"IF($AK16>0,(VLOOKUP($B16,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":29},95.483333333333334,86.488526570048307,5,18.844043207526411,4.0346626715477356,512,null,"n",86.488526570048307,5,null,null,0.70844283500633853,67.644483362521896,null,7,5,18.844043207526411,4.0346626715477356,null,null,64,47,null,{"$f":"(VLOOKUP($B16,'Finish Times'!$A$10:$G$40,6,FALSE))","v":100}]
["Gearhart","More Mischief",null,null,"Beneteau 285",144,{"$f":"193+6","v":199},214,"",0.89766606822262118,{"$f":"IF($AK17>0,(VLOOKUP($B17,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK17>0,(VLOOKUP($B17,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""},{"$f":"IF(AK17>0,(K17+L17/60)-A$3,\" \")","v":" "},"","","","","",null,"n","","",null,null,"","",null,9,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B17,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
["Johnson","Felicite",null,null,"S-2 27 IB",13,{"$f":"188+6","v":194},209,"",0.90171325518485124,{"$f":"IF($AK18>0,(VLOOKUP($B18,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":101},{"$f":"IF($AK18>0,(VLOOKUP($B18,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":34},96.566666666666663,87.075443342350468,6,19.430959979828572,0.58691677230216044,528,null,"n",87.075443342350468,6,null,null,0.70049516771683018,67.644483362521896,null,10,6,19.430959979828572,0.58691677230216044,null,null,null,null,null,{"$f":"(VLOOKUP($B18,'Finish Times'!$A$10:$G$40,6,FALSE))","v":101}]
["Conover","Willawaw",null,null,"Columbia 29",222,227,242,"",0.87565674255691772,{"$f":"IF($AK19>0,(VLOOKUP($B19,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":82},{"$f":"IF($AK19>0,(VLOOKUP($B19,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":15},77.25,67.644483362521896,1,0,null,242,null,"n",67.644483362521896,1,null,null,0.87565674255691772,67.644483362521896,null,11,1,0,null,null,null,null,null,null,{"$f":"(VLOOKUP($B19,'Finish Times'!$A$10:$G$40,6,FALSE))","v":82}]
["Gillespie","Ie Ie Bang Bang",null,null,"Hunter 365",8,148,163,null,0.94073377234242705,{"$f":"IF($AK20>0,(VLOOKUP($B20,'Finish Times'!$A$10:$G$40,6,FALSE)),\"\")","v":""},{"$f":"IF($AK20>0,(VLOOKUP($B20,'Finish Times'!$A$10:$G$40,7,FALSE)),\"\")","v":""}," ","","","","","",null,"n","","",null,null,"","",null,12,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B20,'Finish Times'!$A$10:$G$40,6,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(U21,\" \")","v":" "},{"$f":"IFERROR(V21,\" \")","v":""},{"$f":"IFERROR(N21-$Y$2,\"\")","v":""},"",{"$f":"IFERROR(ROUND((1000/Y21)-900,0),\"\")","v":""},null,"n"," ","",null,null,"","",null,13,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B21,'Finish Times'!$A$10:$G$40,6,FALSE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,14,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B22,'Finish Times'!$A$10:$G$40,6,FALSE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," ","","","","",null,"n"," ","",null,null,"","",null,15,"","","",null,null,null,null,null,{"$f":"(VLOOKUP($B23,'Finish Times'!$A$10:$G$40,6,FALSE))","v":{"$error":"#N/A"}}]
["Race Start Time ",null,null,null,null,null,null,null,null,null,null,null,null,"FLEET THREE & FOUR",null,null,"",null,null,null,null,null,null,null,null,null,null,16,null,null,"",null,null,null,null,null,{"$f":"(VLOOKUP($B24,'Finish Times'!$A$10:$G$40,6,FALSE))","v":{"$error":"#N/A"}}]
["(In case race timer has issues, use clock time as backup and do the math)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,17,null,null,0,null,null,null,null,null,{"$f":"(VLOOKUP($B25,'Finish Times'!$A$10:$G$40,6,FALSE))","v":{"$error":"#N/A"}}]
["(1) Convert seconds to decimal equivalent - see reference sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,18,null,null,0,null,null,null,null,null,{"$f":"(VLOOKUP($B26,'Finish Times'!$A$10:$G$40,6,FALSE))","v":{"$error":"#N/A"}}]
["(2) Multiply time in minutes by circled TCF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,19,null,null,0,null,null,null,null,null,{"$f":"(VLOOKUP($B27,'Finish Times'!$A$10:$G$40,6,FALSE))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["FLEET THREE",null,null,null,null,null,null,null,null,null,null,null,"RACE #"]